/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : PostgreSQL
 Source Server Version : 110005
 Source Host           : localhost:5432
 Source Catalog        : postgres
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 110005
 File Encoding         : 65001

 Date: 26/09/2019 10:42:46
*/


-- ----------------------------
-- Table structure for san_user
-- ----------------------------
DROP TABLE IF EXISTS "public"."san_user";
CREATE TABLE "public"."san_user" (
  "id" varchar(50) COLLATE "pg_catalog"."default" NOT NULL,
  "name" varchar(100) COLLATE "pg_catalog"."default",
  "code" varchar(20) COLLATE "pg_catalog"."default",
  "customer_id" varchar(30) COLLATE "pg_catalog"."default",
  "password" varchar(50) COLLATE "pg_catalog"."default"
)
;
ALTER TABLE "public"."san_user" OWNER TO "postgres";
COMMENT ON COLUMN "public"."san_user"."id" IS 'id';
COMMENT ON COLUMN "public"."san_user"."name" IS '用户名';
COMMENT ON COLUMN "public"."san_user"."code" IS '工号';
COMMENT ON COLUMN "public"."san_user"."customer_id" IS '客户ID';
COMMENT ON COLUMN "public"."san_user"."password" IS '密码';
COMMENT ON TABLE "public"."san_user" IS '用户表';

-- ----------------------------
-- Records of san_user
-- ----------------------------
BEGIN;
INSERT INTO "public"."san_user" VALUES ('222', '222', '2222', NULL, NULL);
INSERT INTO "public"."san_user" VALUES ('333', '333', '3333', NULL, NULL);
INSERT INTO "public"."san_user" VALUES ('111', 'admin', '1111', 'wuzheng', 'admin');
COMMIT;

-- ----------------------------
-- Primary Key structure for table san_user
-- ----------------------------
ALTER TABLE "public"."san_user" ADD CONSTRAINT "san_user_pkey" PRIMARY KEY ("id");
